Hi all.  This is a question relating to Microsoft Access 2010.  I cannot create any total (sum, average, etc) on a run-time generated field in my report.  I'm pretty sure I should be able to, but every time I try, all of those options are greyed out.  I know how to create totals on any other (non-runtime) field in my report.  But when I use the same method on my runtime field, I run into the above issue.

Does anyone know if I'm missing something? 

Thanks in advance.

Hi cagross99,

Based on your description, I suggest you to add a calculated field to the table.

1. Open the table by double-clicking it in the Navigation Pane.

2. Scroll horizontally to the rightmost column in the table, and click the Click to Add column heading.

3. In the list that appears, click Calculated Field, and then click the data type that you want for the result.

     Access displays the Expression Builder.

4. Begin typing the calculation that you want for this field, for example:

    [Quantity] * [Unit Price]

    Note    It is not necessary to precede the expression with an equal sign (=).

5. Click OK.

   Access adds the calculated field, and then highlights the field header so that you can type a field name.

6. Type a name for the calculated field, and then press ENTER.

And please refer to these articles, these articles provide how to create calculated field detailed.

https://support.office.com/en-us/article/Add-a-calculated-field-to-a-table-14a60733-2580-48c2-b402-6de54fafbde3

http://www.gcflearnfree.org/access2010/tables-how-to-create-calculated-fields-and-totals-rows

Hope its helpful.

Regards,

• Edited by guGuuuMy 1 hour 33 minutes ago
• Marked as answer by cagross99 1 hour 16 minutes ago

Thanks for the reply.  Adding a calculated field is the way to go.  It seems that the textbook and standardized tests we use employ incorrect or antiquated terminology.  We can consider this resolved.